package com.cy.detectsys.mapper;

import com.cy.detectsys.entity.DbTargetSubdomain;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author admin
* @description 针对表【db_target_subdomain】的数据库操作Mapper
* @createDate 2024-05-11 02:58:39
* @Entity com.cy.detectsys.entity.DbTargetSubdomain
*/
public interface DbTargetSubdomainMapper extends BaseMapper<DbTargetSubdomain> {


    List<String> selectSubdomains(List<String> param);

    List<String> selectSubdomainsAlive(List<String> param);

    void updateHtmlPath(String subdomain, String absolutePath);

    void updatePngPath(String subdomain, String absolutePath);

    @Select("SELECT distinct tb_net_target_subdomain FROM `detect`.`db_target_subdomain` WHERE `tb_net_target_subdomain_domain` = #{domain}  and tb_net_target_subdomain is not null")
    List<String> selectByDomain(String domain);
}




